The Realization of Decision Support System for Cross-border Transportation based on the Multi-dimensional Database

To provide a more effective data processing system for cross-border transportation for Yunnan Province in China, this paper first analyzed the cross-border transportation data requirements from different perspectives. Then, a systematic structure for the system which is based on the multi-dimensional database was designed. The structure includes three levels: source data level, data processing level and application level. The structure of constellation was designed and adopted to construct the database for the system. The main application of the system includes OLAP and multi-dimensional analysis reports, GIS visualization, and data mining. Later, the paper displayed how the system is realized. The application show proves the effectiveness of the system.